Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$BACKUP_ARCHIVELOG_SUMMARY

`V$BACKUP_ARCHIVELOG_SUMMARY` provides archive log summary information based on archive logs in the backup set or on proxy copies.

Column | Datatype | Description
--- | --- | ---
`NUM_FILES_BACKED` | `NUMBER` | Number of files backed up
`NUM_DISTINCT_FILES_BACKED` | `NUMBER` | Number of distinct archive log files backed up
`MIN_FIRST_CHANGE#` | `NUMBER` | Lowest SCN range value
`MAX_NEXT_CHANGE#` | `NUMBER` | Highest SCN range value
`MIN_FIRST_TIME` | `DATE` | Lowest SCN range time
`MAX_NEXT_TIME` | `DATE` | Highest SCH range time
`INPUT_BYTES` | `NUMBER` | Total input bytes read
`OUTPUT_BYTES` | `NUMBER` | Output size of backups
`COMPRESSION_RATIO` | `NUMBER` | Compression ratio
`INPUT_BYTES_DISPLAY` | `VARCHAR2(4000)` | Displayable format for input bytes
`OUTPUT_BYTES_DISPLAY` | `VARCHAR2(4000)` | Displayable format for output bytes